{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["CAM_TOOL","SYSTEM_INFORMATION","BENEFITING_PROGRAMS","ALLOCATION_STRUCTURE","FUNCTIONAL_MODULES","SUB_MODULES","DETAILS","WEIGHTING_SYSTEM","ALL_SYSTEM_USAGE","RECIPIENT_COUNTS","SHARED_USAGE_LOE","COST_ALLOCATION_PLAN","CHILD_WELFARE_CAP","PROGRAM_BASE_SUMMARY","FORMAT_ALL_SYSTEM_USAGE","FORMAT_SHARED_USAGE_LOE","HELP_MENU","Data Flow","Resource for HelpMenu"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CAM_TOOL","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,21,2],[22,1,36,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"\nCAM-TOOL copyright 2003 - 2011, Department of Health and Human Services (DHHS)/Administration for Children and Families (ACF)/Office of Child Support Enforcement (OCSE)\nCAM-TOOL was originally designed and developed by the State Information Technology Consortium (SITC) as  a companion to the Cost Allocation Methodologies (CAM) Handbook contained in the Cost Allocation Methodologies (CAM) Toolkit for system development.\n\nSpecial thanks to the following organizations for their cooperation and continued support of the CAM-TOOL: \n\nDivision of State and Tribal Systems, Office of Child Support Enforcement, Administration for Children and Families, Washington, DC\n\nDivision of State Systems, Childrens Bureau, Administration on Children, Youth and Families, Administration for Children and Families, Washington, DC\n\nDivision of State Systems, Centers for Medicare and Medicaid Services, Washington, DC\n\nGrants Management Division, Food and Nutrition Service, U.S. Department of Agriculture, Alexandria, VA\n\nMountain Plains Regional Office, Food and Nutrition Service, U.S. Department of Agriculture, Denver, CO\n\nSouthwest Regional Office, Food and Nutrition Service, U.S. Department of Agriculture, Dallas, TX\n\nCost Allocation and Financial Reporting Section, Fiscal Management Services, Texas Department of Human Services\n\nIT Planning and Management Services, Information Technology Services, Kansas Department of Social and Rehabilitation Services\n\n\n"]

{"sheet":"SYSTEM_INFORMATION","index":1,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,4,1,7]]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,null,"SYSTEM INFORMATION","COMMENTS"]
[null,null,"Project/System","CAM TOOL - Enter Project Name on System Information Worksheet"]
[null,null,"Project Description"]
[null,null,"Project/System Type   (select from list)","New Development"]
[null,null,"Target Date of Completion   (mm/dd/yyyy)","2000-01-01"]
[null,null,"Estimated Budget in Dollars   ($)",0]
[null,null,"Current Phase   (select from list)","Requirements"]
[null,null,"Project Leads","Program","Role","Title","Phone Number","Email"]
[null,null,"Insert contact information"]
[]
[]
[null,null,"State Contacts","Program","Role","Title","Phone Number","Email"]
[null,null,"Insert contact information"]
[]
[]
[]
[]
[]
[null,null,"Regional Contacts","Program","Role","Title","Phone Number","Email"]
[null,null,"Insert contact information"]
[]
[]
[]
[]
[]
[null,null,"Federal Contacts","Program","Role","Title","Phone Number","Email"]
[null,null,"Insert contact information"]

{"sheet":"BENEFITING_PROGRAMS","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"PROGRAM_ABBREV","PROGRAM","PROGRAM_SIZE","RECIPIENT_COUNTS","FEDERAL_PROGRAM","FEDERALLY FUNDED?","MATCH RATE"]

{"sheet":"ALLOCATION_STRUCTURE","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"LEVELS","HIERARCHY","DESCRIPTION"]
[null,null,"Level 1","Functional Modules\n      (Program Functional Areas)"]
[null,null,"Level 2","Sub_Modules\n      (Cost categories/cost pools)"]
[null,null,"Level 3","Details"]
[]
[null,null,"ALLOCATION BASE:  Identify the allocation base to be used for all system components."]
[null,null,"   (The allocation base is the measurement you select to track and calculate the cost allocation for all benefiting programs."]
[null,null,"     If the allocation base is anything other than development hours, you must apply a weighting system to all measurements."]
[null,null,null,"Allocation Base:","Description:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"OTHER COMMENTS:"]

{"sheet":"FUNCTIONAL_MODULES","index":4,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","DESCRIPTION","BUDGETED_COSTS","ACTUAL_COSTS"]

{"sheet":"SUB_MODULES","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","SUB_MODULE","DESCRIPTION","ALLOCATION_TYPE","BUDGETED_COSTS","ACTUAL_COSTS"]

{"sheet":"DETAILS","index":6,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","SUB_MODULE","DETAIL","DESCRIPTION"]

{"sheet":"WEIGHTING_SYSTEM","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"Describe the cost allocation weighting system used on this project"]
[]
[null,null,"***NOTE:  Delete these instructions when you document a weighting system***"]
[null,null,"Allocation Base is the measurement you select to track and calculate the development effort for benefiting programs."]
[null,null,"Where the allocation base reflects level of effort, such as development hours, no other weighting is needed. "]
[null,null,"Where the allocation base does NOT reflect level of effort, a weighting system is needed to fairly compare the different efforts. "]
[null,null,"You must develop a weighting system or scale to indicate the level of effort required to develop each module."]
[null,null,"    Weighting system scale should run from low to high, with high number indicating a high effort factor."]
[null,null,"    EX:  a scale from 1 to 5, with 1 meaning \"low\" and 5 meaning \"high\""]
[null,null,"Describe and define your weighting system on this worksheet. "]
[null,null,"On the ALL_SYSTEM_USAGE worksheet, document a weight for each defined development effort. "]
[null,null,"CAM-TOOL will multiply the base value times the weight to assess the level of effort."]

{"sheet":"ALL_SYSTEM_USAGE","index":8,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","SUB_MODULE","DETAIL","USAGE_TYPE","WEIGHT_TYPE","WEIGHT","BASE_VALUE","NUM_SMALL","NUM_LARGE"]

{"sheet":"RECIPIENT_COUNTS","index":9,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","SUB_MODULE","DETAIL","USAGE_TYPE","WEIGHT_TYPE","WEIGHT","BASE_VALUE","NUM_SMALL","NUM_LARGE"]

{"sheet":"SHARED_USAGE_LOE","index":10,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","SUB_MODULE","DETAIL","USAGE_TYPE","WEIGHT_TYPE","WEIGHT","BASE_VALUE","NUM_SMALL","NUM_LARGE"]

{"sheet":"COST_ALLOCATION_PLAN","index":11,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]

{"sheet":"CHILD_WELFARE_CAP","index":12,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[]
[null,null,"Document the breakdown by Child Welfare cost center, and the overall resulting single figure to be used by CAM-TOOL in high level calculations at the program level.  "]

{"sheet":"PROGRAM_BASE_SUMMARY","index":13,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]

{"sheet":"FORMAT_ALL_SYSTEM_USAGE","index":14,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","SUB_MODULE","DETAIL","USAGE_TYPE","WEIGHT_TYPE","WEIGHT","BASE_VALUE","NUM_SMALL","NUM_LARGE"]

{"sheet":"FORMAT_SHARED_USAGE_LOE","index":15,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"FUNCTIONAL_MODULE","SUB_MODULE","DETAIL","USAGE_TYPE","WEIGHT_TYPE","WEIGHT","BASE_VALUE","NUM_SMALL","NUM_LARGE"]

{"sheet":"HELP_MENU","index":16,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"},"Please report problems or question on the CAM-TOOL to your Federal analyst in CB, CMS, FNS, DSTS, or to:\nDirector, Division of State and Tribal Systems, Office of Child Support Enforcement"]
[]
[null,null,"Double click on the following links to access specific User Guide chapters"]
[null,null,"WORKSHEET HELP"]
[]
[null,null,"1 CAM-TOOL Overview"]
[]
[]
[]
[null,null,"2 System Information"]
[]
[]
[]
[]
[null,null,"3 Benefiting Programs"]
[]
[]
[]
[]
[null,null,"4 Allocation Structure"]
[]
[]
[]
[]
[null,null,"5 Functional Modules"]
[]
[]
[]
[]
[null,null,"6 Sub Modules"]
[]
[]
[]
[]
[null,null,"7 Details"]
[]
[]
[]
[null,null,"8 Weighting System"]
[]
[]
[]
[]
[null,null,"9 All System Usage"]
[]
[]
[]
[null,null,"10 Recipient Counts"]
[]
[]
[]
[]
[null,null,"11 Shared Usage LOE"]
[]
[]
[]
[]
[null,null,"12 Cost Allocation Plan"]
[]
[]
[]
[]
[null,null,"13 Child Welfare Cost Allocation"]
[]
[]
[]
[null,null,"14 Program Summary"]
[]
[]
[]
[]
[null,null,"15 Format All System Usage"]
[]
[]
[]
[]
[null,null,"16 Format Shared Usage"]

{"sheet":"Data Flow","index":17,"n_rows":163,"n_cols":8,"rows_kept":163,"cut":false,"hidden":false,"merged":[[27,2,27,3],[36,2,36,3],[44,2,44,3],[50,2,50,3],[58,2,58,3],[66,2,66,3],[69,2,69,3],[82,2,82,3],[93,2,94,2],[93,3,94,3],[11,2,11,3],[18,2,19,2],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[20,2,21,2],[20,4,21,4],[20,5,21,5],[20,6,21,6],[20,7,21,7],[22,4,23,4],[22,5,23,5],[22,6,23,6],[22,7,23,7],[24,2,25,2],[24,4,25,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[22,2,23,2],[59,4,60,4],[59,5,60,5],[59,6,60,6],[61,2,62,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[61,6,62,6],[59,2,60,2],[59,3,60,3],[151,2,151,3],[93,4,94,4],[93,5,94,5],[93,6,94,6],[96,2,96,3],[118,2,118,3],[109,2,109,3],[138,2,138,3]]}
[null,null,{"$f":"Project_System_Name","v":"CAM TOOL - Enter Project Name on System Information Worksheet"}]
[null,null,"The following table lists and describes the CAM-TOOL Worksheet Data Fields and the flow of data between worksheets. "]
[]
[null,null,"Please note:"]
[null,null,"Required Fields are those needed for the automated calculations completed by the tool. A required field may be empty of data,"]
[null,null,null," but the field itself, i.e, the data column, must exist to allow CAM-TOOL calculations to run."]
[null,null,"Reference Fields are necessary to describe or characterize the cost allocation scenario, but are not used in CAM-TOOL calculations."]
[null,null,"Comments for each worksheet include identification of the worksheet from which data was copied, and the worksheet to which it will be copied."]
[]
[]
[null,null,"Worksheet","Field","Status","Data Type","Entry","Comment"]
[null,null,"System Information Worksheet"]
[null,null,null,"System / Project Name","Required ","Alphanumeric","Entry","Copied to header of all other worksheets"]
[null,null,null,"Estimated Budget in Dollars","Reference","Numeric","Entry","Compare manually to Budget figure entered to Cost Allocation Plan Worksheet"]
[null,null,null,"Project Description","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Project/System Type","Reference","Alphanumeric","Dropdown List","Reference field."]
[null,null,null,"Target Date of Completion","Reference","Date","Entry","Reference field."]
[null,null,null,"Current Phase","Reference","Alphanumeric","Dropdown List","Reference field."]
[null,null,null,"Project Leads","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null," / Program / Role / Title / Phone Number / Email"]
[null,null,null,"State Contacts","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null," / Program / Role / Title / Phone Number / Email"]
[null,null,null,"Regional Contacts","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null," / Program / Role / Title / Phone Number / Email"]
[null,null,null,"Federal Contacts","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null," / Program / Role / Title / Phone Number / Email"]
[]
[null,null,"Benefiting Programs Worksheet"]
[null,null,null,"Program_Abbrev ","Required","Alphanumeric","Entry","Copied to All System Usage, Shared Usage LOE, Cost Allocation Plan, as well as automated calculations.  This is the data item most frequently used by the CAM-TOOL"]
[null,null,null,"Program ","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Program_Size ","Required  ","Alphanumeric","Dropdown List","Used in calculations in Recipient Counts, All System Usage, and Shared Usage LOE worksheets"]
[null,null,null,"Recipient_Counts ","Required  ","Numeric","Entry","Copied to Recipient Counts and used in automated calculations."]
[null,null,null,"Federal Program ","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Federally Funded? ","Reference ","Alphanumeric","Dropdown List","Reference field."]
[null,null,null,"Match Rate   ","Required  ","Numeric","Entry","Copied to Cost Allocation Plan and used in automated calculations"]
[]
[null,null,"Allocation Structure Worksheet"]
[null,null,null,"Functional Modules description ","Reference","Alphanumeric","Entry","Reference field"]
[null,null,null,"Sub_Modules description ","Reference","Alphanumeric","Entry","Reference field"]
[null,null,null,"Details description ","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Allocation Base ","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Allocation Base description ","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Comments ","Reference","Alphanumeric","Entry","Reference field."]
[]
[null,null,"Functional Modules Worksheet"]
[null,null,null,"Functional Module","Required","Alphanumeric","Entry","Copied to Sub_Modules worksheet.  "]
[null,null,null,"Description","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Budgeted Costs ","Reference","Numeric","Entry","Reference field."]
[null,null,null,"Actual Cost","Reference","Numeric","Entry","Reference field."]
[]
[null,null,"Sub_Modules Worksheet"]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry ","Copied by the CAM-TOOL from Functional Modules spreadsheet.  "]
[null,null,null,"Sub Module","Required  ","Alphanumeric","Entry","Required field.  "]
[null,null,null,"Description ","Reference","Alphanumeric","Entry","Reference field."]
[null,null,null,"Allocation Type","Required  ","Alphanumeric","Dropdown List","Required field.  "]
[null,null,null,"Budgeted Costs","Reference","Numeric","Entry","Reference field."]
[null,null,null,"Actual Cost","Reference","Numeric","Entry","Reference field."]
[]
[null,null,"Details Worksheet"]
[null,null,null,"Functional Module ","Required","Alphanumeric","Copied Entry","Copied by the CAM-TOOL from Functional Modules spreadsheet. "]
[null,null,null,null,null,null,null,"Copied to All System Usage, Recipient Counts, Shared Usage worksheets"]
[null,null,null,"Sub_Module","Required  ","Alphanumeric","Copied Entry","Copied by the CAM-TOOL from Functional Modules spreadsheet.  "]
[null,null,null,null,null,null,null,"Copied to All System Usage, Recipient Counts, Shared Usage worksheets"]
[null,null,null,"Detail","Required  ","Alphanumeric","Entry","Copied to All System Usage, Recipient Counts, Shared Usage worksheets"]
[null,null,null,"Description","Reference","Alphanumeric","Entry","Reference field."]
[]
[null,null,"Weighting System Worksheet"]
[null,null,null,"No defined fields.","Reference","Alphanumeric","Entry","Reference.  Documents the design and intent of weighting system, including the weight type and the and the specific weights to be used in calculating usage and a program shares"]
[]
[null,null,"All System Usage Worksheet"]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from Details worksheet."]
[null,null,null,"Sub Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from Details worksheet."]
[null,null,null,"Detail ","Required","Alphanumeric","Copied Entry","Required field.  Copied from Details worksheet."]
[null,null,null,"Program Abbrev","Required","Alphanumeric","Copied Entry","Required field.  Copied from Benefiting Programs worksheet."]
[null,null,null,"Usage Type","Required","Alphanumeric","Calculated","Required field.  Calculated by Tally Usage by Program Size command button."]
[null,null,null,"Weight Type","Required","Alphanumeric","Entry","Required with weighting system.  Entered in Enter Weights or Base Values command button. "]
[null,null,null,"Weight","Required","Numeric","Entry","Required with weighting system.  Entered in Enter Weights or Base Values command button."]
[null,null,null,"Base Value","Required","Numeric","Entry","Required field.  Entered in Enter Weights or Base Values command button. "]
[null,null,null,"Num_Small","Required","Numeric","Calculated","Required field.  Calculated by Tally Usage by Program Size command button. "]
[null,null,null,"Num_Large","Required","Numeric","Calculated","Required field.  Calculated by Tally Usage by Program Size command button."]
[null,null,null,"Usage","Required","Alphanumeric Usage = X","Entry","Required field.  Entered in Enter Usage =X command button.  Indicate the programs that use each module. "]
[]
[null,null,"Recipient Counts Worksheet"]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Sub Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Detail","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Program Abbrev","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Usage Type","Required","Alphanumeric","Calculated","Required field.  Copied from All System Usage worksheet"]
[null,null,null,"Weight Type","Required","Alphanumeric","Copied Entry","Required with weighting system.  Copied from All System Usage worksheet"]
[null,null,null,"Weight","Required","Numeric","Copied Entry","Required with weighting system.  Copied from All System Usage worksheet."]
[null,null,null,"Base Value","Required","Numeric","Copied Entry","Required field.  Copied from All System Usage worksheet"]
[null,null,null,"Num_Small","Required","Numeric","Calculated","Required field.  Copied from All System Usage worksheet"]
[null,null,null,"Num_Large","Required","Numeric","Calculated","Required field. Copied from All System Usage worksheet"]
[null,null,null,"Usage","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,null,null,null,null,"Xs replaced with recipient counts by Assign the Benefiting Programs Worksheet Recipient Counts command button or by Assign Recipient Counts by Program command button."]
[]
[null,null,"Shared Usage LOE Worksheet"]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from Recipient Counts worksheet."]
[null,null,null,"Sub Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from Recipient Counts worksheet."]
[null,null,null,"Detail ","Required","Alphanumeric","Copied Entry","Required field.  Copied from Recipient Counts worksheet."]
[null,null,null,"Program Abbrev","Required","Alphanumeric","Copied Entry","Required field.  Copied from Recipient Counts worksheet."]
[null,null,null,"Usage Type","Required","Alphanumeric","Calculated","Required field.  Copied from Recipient Counts worksheet."]
[null,null,null,"Weight Type","Required","Alphanumeric","Copied Entry","Required with weighting system.  Copied from Recipient Counts worksheet."]
[null,null,null,"Weight ","Required","Numeric","Copied Entry","Required with weighting system.  Copied from Recipient Counts worksheet."]
[null,null,null,"Base Value","Required","Numeric","Copied Entry","Required field.  Copied from All System Usage Counts worksheet."]
[null,null,null,"Num_Small","Required","Numeric","Calculated","Required field.  Copied from Recipient Counts worksheet."]
[null,null,null,"Num_Large","Required","Numeric","Calculated","Required field.  Copied from Recipient Counts worksheet."]
[null,null,null,"Usage ","Required","Alphanumeric","Calculated","Required field.  Calculated by Calculate Shared Usage Level of Effort (LOE) command button on Recipient Counts worksheet."]
[]
[null,null,"Cost Allocation Plan Worksheet"]
[null,null,null,"Program Abbrev","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Program Share of Cost ","Required","Numeric","Calculated","Required field.  Calculated by Create Cost Allocation Plan Summary command button on Shared Usage LOE worksheet."]
[null,null,null,"Allocated Budget or Allocated Section Amount","Required","Numeric","Entry","Required field.  Amount of total budget cost to be allocated, or total section cost to be allocated."]
[null,null,null,"Share Amount","Required","Numeric","Calculated","Required field.  Calculated by Cost Allocation Worksheet upon entry of Budget Amount."]
[null,null,null,"Match Rate","Required","Numeric","Copied Entry","Required.  Copied by Create Cost Allocation Plan Summary command button on Shared Usage LOE worksheet. "]
[null,null,null,"Federal Share ($) FFP","Required","Numeric","Calculated","Required field.  Calculated by Cost Allocation Worksheet upon entry of Budget Amount."]
[null,null,null,"State Share ($)","Required","Numeric","Calculated","Required field.  Calculated by Cost Allocation Worksheet upon entry of Budget Amount."]
[]
[null,null,"Child Welfare CAP Worksheet"]
[null,null,null,"No defined fields.","Reference","Alphanumeric","Entry","Reference.  Documents breakdown by Child Welfare cost center, and the overall resulting single figure to be used by the CAM-TOOL in high level calculations at the program level.  "]
[]
[null,null,"Program Summary Worksheet","When populated from Create Program Base Summary (ALL) command button on All System Usage worksheet:"]
[null,null,null,"Program Abbrev","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Sub Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Detail ","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Usage Type","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Base Value ","Required","Numeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[]
[null,null,null,"When populated from Create Program Base Summary (Shared) command button on Shared Usage LOE worksheet:"]
[null,null,null,"Program Abbrev","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Sub Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Detail ","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Usage Type","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Base Value ","Required","Numeric","Copied Entry","Required field.  Calculated from Shared Usage LOE worksheet."]
[null,null,null,"Final Value","Required","Numeric","Calculated","Required field.  Calculated from Shared Usage LOE worksheet."]
[]
[null,null,"Format All Systems Usage Worksheet"]
[null,null,null,"Program Abbrev ","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Sub Module ","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Detail ","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Usage Type","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Weight Type","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Weight","Required","Numeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Base Value","Required","Numeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Num_Small","Required","Numeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Num_Large","Required","Numeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[null,null,null,"Program Usage","Required","Alphanumeric","Copied Entry","Required field.  Copied from All System Usage worksheet."]
[]
[null,null,"Format Shared Usage Worksheet"]
[null,null,null,"Program Abbrev ","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Functional Module","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Sub Module ","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Detail ","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Usage Type","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Weight Type","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Weight","Required","Numeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Base Value","Required","Numeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Num_Small","Required","Numeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Num_Large","Required","Numeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]
[null,null,null,"Program Usage","Required","Alphanumeric","Copied Entry","Required field.  Copied from Shared Usage LOE worksheet."]

{"sheet":"Resource for HelpMenu","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}